Skip Headers

Oracle® Streams Concepts and Administration 10g Release 2 (10.2) Part Number B14229-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# 19 Monitoring a Streams Environment

This chapter lists the static data dictionary views and dynamic performance views related to Streams. You can use these views to monitor your Streams environment.

This chapter contains these topics:

- Summary of Streams Static Data Dictionary Views

- Summary of Streams Dynamic Performance Views

Note: The Streams tool in the Oracle Enterprise Manager Console is also an excellent way to monitor a Streams environment. See the online help for the Streams tool for more information.

See Also: Oracle Database Reference for information about the data dictionary views described in this chapter Oracle Streams Replication Administrator's Guide for information about monitoring a Streams replication environment

## Summary of Streams Static Data Dictionary Views

Table 19-1 lists the Streams static data dictionary views.

Table 19-1 Streams Static Data Dictionary Views

ALL_ Views | DBA_ Views | USER_ Views
--- | --- | ---
`ALL_APPLY` | `DBA_APPLY` | N/A
`ALL_APPLY_CONFLICT_COLUMNS` | `DBA_APPLY_CONFLICT_COLUMNS` | N/A
`ALL_APPLY_DML_HANDLERS` | `DBA_APPLY_DML_HANDLERS` | N/A
`ALL_APPLY_ENQUEUE` | `DBA_APPLY_ENQUEUE` | N/A
`ALL_APPLY_ERROR` | `DBA_APPLY_ERROR` | N/A
`ALL_APPLY_EXECUTE` | `DBA_APPLY_EXECUTE` | N/A
N/A | `DBA_APPLY_INSTANTIATED_GLOBAL` | N/A
N/A | `DBA_APPLY_INSTANTIATED_OBJECTS` | N/A
N/A | `DBA_APPLY_INSTANTIATED_SCHEMAS` | N/A
`ALL_APPLY_KEY_COLUMNS` | `DBA_APPLY_KEY_COLUMNS` | N/A
N/A | `DBA_APPLY_OBJECT_DEPENDENCIES` | N/A
`ALL_APPLY_PARAMETERS` | `DBA_APPLY_PARAMETERS` | N/A
`ALL_APPLY_PROGRESS` | `DBA_APPLY_PROGRESS` | N/A
N/A | `DBA_APPLY_SPILL_TXN` | N/A
`ALL_APPLY_TABLE_COLUMNS` | `DBA_APPLY_TABLE_COLUMNS` | N/A
N/A | `DBA_APPLY_VALUE_DEPENDENCIES` | N/A
`ALL_CAPTURE` | `DBA_CAPTURE` | N/A
`ALL_CAPTURE_EXTRA_ATTRIBUTES` | `DBA_CAPTURE_EXTRA_ATTRIBUTES` | N/A
`ALL_CAPTURE_PARAMETERS` | `DBA_CAPTURE_PARAMETERS` | N/A
`ALL_CAPTURE_PREPARED_DATABASE` | `DBA_CAPTURE_PREPARED_DATABASE` | N/A
`ALL_CAPTURE_PREPARED_SCHEMAS` | `DBA_CAPTURE_PREPARED_SCHEMAS` | N/A
`ALL_CAPTURE_PREPARED_TABLES` | `DBA_CAPTURE_PREPARED_TABLES` | N/A
`ALL_EVALUATION_CONTEXT_TABLES` | `DBA_EVALUATION_CONTEXT_TABLES` | `USER_EVALUATION_CONTEXT_TABLES`
`ALL_EVALUATION_CONTEXT_VARS` | `DBA_EVALUATION_CONTEXT_VARS` | `USER_EVALUATION_CONTEXT_VARS`
`ALL_EVALUATION_CONTEXTS` | `DBA_EVALUATION_CONTEXTS` | `USER_EVALUATION_CONTEXTS`
`ALL_FILE_GROUP_EXPORT_INFO` | `DBA_FILE_GROUP_EXPORT_INFO` | `USER_FILE_GROUP_EXPORT_INFO`
`ALL_FILE_GROUP_FILES` | `DBA_FILE_GROUP_FILES` | `USER_FILE_GROUP_FILES`
`ALL_FILE_GROUP_TABLES` | `DBA_FILE_GROUP_TABLES` | `USER_FILE_GROUP_TABLES`
`ALL_FILE_GROUP_TABLESPACES` | `DBA_FILE_GROUP_TABLESPACES` | `USER_FILE_GROUP_TABLESPACES`
`ALL_FILE_GROUP_VERSIONS` | `DBA_FILE_GROUP_VERSIONS` | `USER_FILE_GROUP_VERSIONS`
`ALL_FILE_GROUPS` | `DBA_FILE_GROUPS` | `USER_FILE_GROUPS`
N/A | `DBA_HIST_STREAMS_APPLY_SUM` | N/A
N/A | `DBA_HIST_STREAMS_CAPTURE` | N/A
N/A | `DBA_HIST_STREAMS_POOL_ADVICE` | N/A
`ALL_PROPAGATION` | `DBA_PROPAGATION` | N/A
N/A | `DBA_REGISTERED_ARCHIVED_LOG` | N/A
`ALL_RULE_SET_RULES` | `DBA_RULE_SET_RULES` | `USER_RULE_SET_RULES`
`ALL_RULE_SETS` | `DBA_RULE_SETS` | `USER_RULE_SETS`
`ALL_RULES` | `DBA_RULES` | `USER_RULES`
N/A | `DBA_STREAMS_ADD_COLUMN` | N/A
N/A | `DBA_STREAMS_ADMINISTRATOR` | N/A
N/A | `DBA_STREAMS_DELETE_COLUMN` | N/A
`ALL_STREAMS_GLOBAL_RULES` | `DBA_STREAMS_GLOBAL_RULES` | N/A
`ALL_STREAMS_MESSAGE_CONSUMERS` | `DBA_STREAMS_MESSAGE_CONSUMERS` | N/A
`ALL_STREAMS_MESSAGE_RULES` | `DBA_STREAMS_MESSAGE_RULES` | N/A
`ALL_STREAMS_NEWLY_SUPPORTED` | `DBA_STREAMS_NEWLY_SUPPORTED` | N/A
N/A | `DBA_STREAMS_RENAME_COLUMN` | N/A
N/A | `DBA_STREAMS_RENAME_SCHEMA` | N/A
N/A | `DBA_STREAMS_RENAME_TABLE` | N/A
`ALL_STREAMS_RULES` | `DBA_STREAMS_RULES` | N/A
`ALL_STREAMS_SCHEMA_RULES` | `DBA_STREAMS_SCHEMA_RULES` | N/A
`ALL_STREAMS_TABLE_RULES` | `DBA_STREAMS_TABLE_RULES` | N/A
`ALL_STREAMS_TRANSFORM_FUNCTION` | `DBA_STREAMS_TRANSFORM_FUNCTION` | N/A
N/A | `DBA_STREAMS_TRANSFORMATIONS` | N/A
`ALL_STREAMS_UNSUPPORTED` | `DBA_STREAMS_UNSUPPORTED` | N/A

## Summary of Streams Dynamic Performance Views

The Streams dynamic performance views are:

- `V$BUFFERED_PUBLISHERS`

- `V$BUFFERED_QUEUES`

- `V$BUFFERED_SUBSCRIBERS`

- `V$PROPAGATION_RECEIVER`

- `V$PROPAGATION_SENDER`

- `V$RULE`

- `V$RULE_SET`

- `V$RULE_SET_AGGREGATE_STATS`

- `V$STREAMS_APPLY_COORDINATOR`

- `V$STREAMS_APPLY_READER`

- `V$STREAMS_APPLY_SERVER`

- `V$STREAMS_CAPTURE`

- `V$STREAMS_POOL_ADVICE`

- `V$STREAMS_TRANSACTION`

Note: When monitoring a Real Application Clusters (RAC) database, use the GV$ versions of the dynamic performance views. To collect elapsed time statistics in these dynamic performance views, set the `TIMED_STATISTICS` initialization parameter to `true`.